| Welcome, Guest |
You have to register before you can post on our site.
|
| Forum Statistics |
» Members: 6,511
» Latest member: snaptrap
» Forum threads: 2,233
» Forum posts: 12,034
Full Statistics
|
| Online Users |
There are currently 518 online users.
» 0 Member(s) | 516 Guest(s)
Bing, Google
|
| Latest Threads |
I humor myself
Forum: Programming
Last Post: nami16504
Yesterday, 04:28 PM
» Replies: 5
» Views: 8,043
|
Command does not work in-...
Forum: Pawn Scripting
Last Post: PANZEHIR_
2024-11-23, 06:36 PM
» Replies: 0
» Views: 43
|
White Screen
Forum: Support
Last Post: Phat202146_real
2024-11-21, 02:50 PM
» Replies: 0
» Views: 43
|
I get error 021 using y_h...
Forum: Pawn Scripting
Last Post: daniscript18
2024-11-18, 11:34 PM
» Replies: 0
» Views: 61
|
Il reste des français sur...
Forum: French/Fran?ais
Last Post: tysanio
2024-11-18, 05:39 AM
» Replies: 2
» Views: 469
|
Object creation issues
Forum: Programming
Last Post: K1271
2024-11-15, 11:51 PM
» Replies: 0
» Views: 56
|
Is the SAMP Hosting the s...
Forum: General Discussions
Last Post: OperaGX
2024-11-14, 09:33 PM
» Replies: 0
» Views: 76
|
Run time error 19: "File ...
Forum: Pawn Scripting
Last Post: Rexey
2024-11-14, 03:50 AM
» Replies: 0
» Views: 65
|
How to Compile Your Gamem...
Forum: Tutorials
Last Post: thelante
2024-11-13, 08:50 AM
» Replies: 3
» Views: 477
|
Modeller wanted
Forum: Development Updates
Last Post: acc.gangbeni
2024-11-11, 05:10 PM
» Replies: 9
» Views: 16,521
|
|
|
| cache_insert_id always return 0 |
|
Posted by: Axitz - 2022-03-30, 07:41 AM - Forum: Pawn Scripting
- Replies (5)
|
 |
Hi, sorry how bad this was.
I've created a team and the table is also is AI mode. There are multiples team in the query but whenever server restart or player quit, then create team, it always started at 0 again.
PHP Code: forward TeamCreated(b);
public TeamCreated(b)
{
? ? TeamInfo[b][TeamID] = cache_insert_id();
? ? teamidd;
? ? printf("New Group is created: [%d]", teamidd );
}
PHP Code: if(strcmp(usage, "create", false) == 0)
{
? ? if(!strlen(usage1)) return SCP(playerid, "create <teamname>");
? ? if(strlen(usage1) < 5 || strlen(usage1) > 30) return SendClientError(playerid, "Your team name is too short or too long! (Min 5, Max 30 chars)");
? ? new tmID = teamidd;
? ? if(PlayerInfo[playerid][tplayerteam] != -1) return SendClientError(playerid, "You are already in a team. /team leave");
? ? TeamInfo[tmID][TeamID] = tmID;
? ? PlayerInfo[playerid][tplayerteam] = tmID;
? ? PlayerInfo[playerid][tranklvl] = 0;
? ? myStrcpy(PlayerInfo[playerid][TPTeamName],usage1);
? ? myStrcpy(PlayerInfo[playerid][trankname],"Children");
? ? TeamInfo[tmID][TActive]=true;
new sQuery[528];
mysql_format(sqldb, sQuery, sizeof sQuery, "INSERT INTO `TeamInfo` (`TeamID`, `TeamName`, `StartRank`) VALUES (%d,'%e', 'Children')",tmID,usage1);
mysql_tquery(sqldb, sQuery, "TeamCreated", "i",tmID);
}
else
{
SCP(playerid, "<create> <input>");
}
return 1;
}
|
|
|
|
| Which one is better? |
|
Posted by: Zow - 2022-01-26, 09:29 PM - Forum: Pawn Scripting
- Replies (2)
|
|
PHP Code: #define SendErrorMessage(%0, %1) SendClientMessage(%0, COLOR_RED, "[*]{FFFFFF} "%1)
PHP Code: SendErrorMessage(playerid, const msg[]) {
? ? new
? ? ? ? string[145];
? ? format(string, sizeof(string), "[*]"C_WHITE" %s", msg);
? ? return SendClientMessage(playerid, COLOR_RED, string);
}
I just want to know how different
|
|
|
|
| MySQL Query |
|
Posted by: Slade - 2022-01-24, 04:55 PM - Forum: Pawn Scripting
- Replies (1)
|
|
So basically i've done so many scripts using MySQL, but never had this problem and simply not finding way to solve it because i don't even understand why it happens.
I will explain here, I don't really need to post code since my other scripts with literally same code works great, I also tried to google it, but no luck.
So this is case: I've switched House system on old gamemode from Dini to MySQL. I've switched data by loading with Dini, saving with MySQL. Then i created loading. First I have used TQuery with callback, and got this errors:
Code: [01/24/22 17:50:46] [plugins/mysql] cache_get_value_name_float: no active cache (C:\Users\llc\Documents\GM\gamemodes\YUBGM.pwn:24580)
[01/24/22 17:50:46] [plugins/mysql] cache_get_value_name_float: no active cache (C:\Users\llc\Documents\GM\gamemodes\YUBGM.pwn:24581)
[01/24/22 17:50:46] [plugins/mysql] cache_get_value_name_float: no active cache (C:\Users\llc\Documents\GM\gamemodes\YUBGM.pwn:24582)
This happens for every row in every iteration of cache num rows, table has around 1100 houses.
I've done it also with mysql_query and cache variable, same error appears.
Updated MySQL to latest version.
Changed variable names from?cache_get_value_name_float to?cache_get_value_float but still the same.
Important thing is: I printed second row after every iteration and cache function, and first 2 rows are getting loaded, and all others are not.
So yes i got 2 first selected rows loaded, others are literally ignored in loop.
Any possible solutions ?
|
|
|
|
Desolation Roleplay |
|
Posted by: Awide - 2022-01-21, 05:11 PM - Forum: Gamemodes
- Replies (1)
|
 |
Written 99.5% by me entirely from scratch. Put countless days and?nights into this gamemode.
Featuring NPC zombies, bandits, looting, factions, cities, inventory, item system, housing and businesses. I made it work on both Linux and Windows servers.
I am not willing to provide support nor answer questions. If you need the database (otherwise you cannot use the inventory and looting) PM me (DC: Awide#0896) and I will?consider your offer.
Otherwise, enjoy!
https://github.com/Awide/Desolation-SAMP
|
|
|
|
| Problem with plugin development |
|
Posted by: Davee52 - 2022-01-18, 11:41 AM - Forum: Programming
- No Replies
|
|
Hy everybody! I followed the instructions in the Plugin Development topic on the site, and I get errors as I include the invoke.hxx . I downloaded it on the link, added the file to the project, and included it in the code, but it gives me these errors:
https://imgur.com/a/Yamr46K
Thank you if you could lead me to success.
|
|
|
|
|
![[Image: mysql.png]](https://i.ibb.co/yfmNJwy/mysql.png)
![[Image: noxxer.png]](https://i.postimg.cc/MKCKYHmT/noxxer.png)